﻿CREATE TABLE [dbo].[Score] (
    [ScoreID]   INT          IDENTITY (1, 1) NOT NULL,
    [WeekID]    INT          NULL,
    [HomeTeam]  INT          NULL,
    [AwayTeam]  INT          NULL,
    [HomeScore] INT          NULL,
    [AwayScore] INT          NULL,
    [TimeStats] VARCHAR (50) NULL,
    [Final]     BIT          NULL,
    CONSTRAINT [PK_Score] PRIMARY KEY CLUSTERED ([ScoreID] ASC),
    CONSTRAINT [FK_Score_Team] FOREIGN KEY ([HomeTeam]) REFERENCES [dbo].[Team] ([TeamID]),
    CONSTRAINT [FK_Score_Team1] FOREIGN KEY ([AwayTeam]) REFERENCES [dbo].[Team] ([TeamID]),
    CONSTRAINT [FK_Score_Week] FOREIGN KEY ([WeekID]) REFERENCES [dbo].[Week] ([WeekID])
);

